Prerequisites
Before you can use Microsoft Azure Synapse Analytics as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:
Install the Required Client
Install SQL Server Native Client 11 (for connecting to Microsoft Azure Synapse Analytics) on the Compose machine.
Permissions
The user specified in the Microsoft Azure Synapse Analytics connection settings must be granted the following permissions.
Permission required for the specified target database:
The Compose must be granted the db_owner user role on the specified target database.
Permission required for the master database:
The Compose must be granted SELECT access (by adding the user to the master database and then to the db_readers role, for example).
Open the Required Firewall Port(s)
- When Compose runs on a machine outside Azure - Open port 1433 for outbound traffic.
- When Compose runs on an AzureVM - Open the following ports for outbound traffic:
- 1433
- 11000-11999
- 14000-14999